Hierarchy integration in the design of data warehouses
نویسندگان
چکیده
Face to their merger and/or collaboration with partners, today’s enterprises often need to integrate several databases. As a result, their decision making process ends up analyzing data coming from various databases. While database integration has been thoroughly examined, it is only recently that the integration of multidimensional models has drawn attention. A multidimensional model is a data model that facilitates the analysis operations during the decision making process. It organizes data into facts that can be analyzed according to dimensions represented through hierarchies. This paper presents an integration process for the hierarchy concept. In particular, it proposes a set of basic integration operations and constraints that produce a multidimensional model that is loadable from different data sources. It illustrates the integration process through examples.
منابع مشابه
Fuzzy multi-criteria selection procedures in choosing data source
Technology assessment and selection has a substantial impact on organizations procedures in regards to technology transfer. Technological decisions are usually made by a group of experts, and whereby integrity of these viewpoints to a single decision can be quite complex. Today, operational databases and data warehouses exist to manage and organize data with specific features and henceforth, th...
متن کاملDesign of Oil Refineries Hydrogen Network Using Process Integration Principles
This paper describes the application of process integration principles to the design of oil refineries hydrogen network. In this regard, a design hierarchy as well as heuristics and required guidelines are proposed. The recommended rules compensate lack of procedure to the design and make the design process easier. The guiding principles of the design are based upon pinch technology and ext...
متن کاملA Hierarchy Topology Design Using a Hybrid Evolutionary Algorithm in Wireless Sensor Networks
Wireless sensor network a powerful network contains many wireless sensors with limited power resource, data processing, and transmission abilities. Wireless sensor capabilities including computational capacity, radio power, and memory capabilities are much limited. Moreover, to design a hierarchy topology, in addition to energy optimization, find an optimum clusters number and best location of ...
متن کاملConceptual Design of XML Document Warehouses
EXtensible Markup Language (XML) has emerged as the dominant standard in describing and exchanging data among heterogeneous data sources. XML with its self-describing hierarchical structure and its associated XML Schema (XSD) provides the flexibility and the manipulative power needed to accommodate complex, disconnected, heterogeneous data. The issue of large volume of data appearing deserves i...
متن کاملA general model for the design of data warehouses
Design and implementation of data warehouses remain delicate tasks which are led by experts. Nevertheless it would be interesting to allow the users to define and to build themselves their system through a simple and flexible process. In particular, in the field of production systems, exists the need to integrate data from various sources and to analyze them in order to extract knowledge for op...
متن کامل